﻿
CREATE FUNCTION [dbo].[IsPulledEx_1]
	(@Credit text
	)
RETURNS bit
AS
BEGIN

IF @Credit IS NULL RETURN 0
IF CONVERT(varchar,@Credit) = '' RETURN 0

IF @Credit LIKE '% NO RECORD,%' OR
	 @Credit LIKE '%NO RECORD FOUND FOR THIS INQUIRY%' OR
	 @Credit LIKE '%SYS_UNAVAIL%' OR
	 @Credit LIKE '%System Unavailable%' OR
	 @Credit LIKE '%SYSTEM TEMPORARILY UNAVAILABLE%' OR
	 @Credit LIKE '%Cannot find server or DNS Error%' OR
	 @Credit LIKE '%Password is case sensitive%'
	RETURN 0

RETURN 1

END

